Alignment

Data in cells can be aligned horizontally and vertically.

To align data horizontally, use one of the commands described in the table below:

Cell position

Button on the Home tab, in the Alignment group

Command from the command menu in macOS

Keyboard shortcut

Windows, Linux

macOS

Align left

editor_alignment_left_icon

Format > Alignment > Left

Ctrl+L

⌘Cmd+L

Center

editor_alignment_center_icon_gray

Format > Alignment > Center

Ctrl+E

⌘Cmd+E

Align right

editor_alignment_right_icon

Format > Alignment > Right

Ctrl+R

⌘Cmd+R

Justify

editor_alignment_justify_icon_gray

Format > Alignment > Justify

Ctrl+J

⌘Cmd+J

To align data vertically, use one of the commands described in the table below:

Cell position

Button on the Home tab, in the Alignment group

Command from the command menu in macOS

Top

editor_vertical_alignment_top_icon

Format > Alignment > Top

Middle

editor_vertical_alignment_middle_icon

Format > Alignment > Middle

Bottom

editor_vertical_alignment_bottom_icon

Format > Alignment > Bottom

© New Cloud Technologies Ltd., 2013—2025
MyOffice Spreadsheet 3.5E